Tabela ContractLimit

Definicja tabeli ContractLimit

Name

ContractLimit

Code

ContractLimit

Comment

PL: Definicja zasad limitowania umowy.
Moze dotyczyc benefit planu, opcji lub grupy opcji.
EN: Contract limit rules description


Lista kolumn tabeli ContractLimit

Name

Code

ContractLimitID

ContractLimitID

LimitPeriodID

LimitPeriodID

LimitKindID

LimitKindID

CurrencyID

CurrencyID

LimitBaseID

LimitBaseID

LimitTypeID

LimitTypeID

OverLimitActionID

OverLimitActionID

UnitsCount

UnitsCount

StartDT

StartDT

StopDT

StopDT


Kolumna ContractLimitID tabeli ContractLimit

Definicja kolumny ContractLimitID tabeli ContractLimit

Name

ContractLimitID

Code

ContractLimitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LimitPeriodID tabeli ContractLimit

Definicja kolumny LimitPeriodID tabeli ContractLimit

Name

LimitPeriodID

Code

LimitPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LimitKindID tabeli ContractLimit

Definicja kolumny LimitKindID tabeli ContractLimit

Name

LimitKindID

Code

LimitKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CurrencyID tabeli ContractLimit

Definicja kolumny CurrencyID tabeli ContractLimit

Name

CurrencyID

Code

CurrencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LimitBaseID tabeli ContractLimit

Definicja kolumny LimitBaseID tabeli ContractLimit

Name

LimitBaseID

Code

LimitBaseID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LimitTypeID tabeli ContractLimit

Definicja kolumny LimitTypeID tabeli ContractLimit

Name

LimitTypeID

Code

LimitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OverLimitActionID tabeli ContractLimit

Definicja kolumny OverLimitActionID tabeli ContractLimit

Name

OverLimitActionID

Code

OverLimitActionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli ContractLimit

Definicja kolumny UnitsCount tabeli ContractLimit

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,6)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ContractLimit

Definicja kolumny StartDT tabeli ContractLimit

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ContractLimit

Definicja kolumny StopDT tabeli ContractLimit

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli ContractLimit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractLimit

Definicja klucza Identifier_1 tabeli ContractLimit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment